CREATE TABLE [dbo].[ExportType]
(
[ExportTypeKey] [uniqueidentifier] NOT NULL,
[ExportType] [nvarchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExportType_ExportType] DEFAULT (''),
[Name] [nvarchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExportType_Name] DEFAULT (''),
[NavMarker] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ExportType_NavMarker] DEFAULT (N'PE.Runtime'),
[ProcessEngineTypeKey] [uniqueidentifier] NULL,
[IsQueryExport] [bit] NOT NULL CONSTRAINT [DF_ExportType_IsQueryExport] DEFAULT ((0))
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ExportType] ADD CONSTRAINT [PK_ExportType] PRIMARY KEY CLUSTERED ([ExportTypeKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ExportType] ADD CONSTRAINT [AK_ExportType_ExportType] UNIQUE NONCLUSTERED ([ExportType]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ExportType_ProcessEngineTypeKey] ON [dbo].[ExportType] ([ProcessEngineTypeKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ExportType] ADD CONSTRAINT [FK_ExportType_ProcessEngineType] FOREIGN KEY ([ProcessEngineTypeKey]) REFERENCES [dbo].[ProcessEngineType] ([ProcessEngineTypeKey])
GO